package cn.huijielong.modules.cm.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import cn.huijielong.common.utils.Query;
import cn.huijielong.modules.sys.dao.BaseDao;

/**
 * 省
 * 
 * @author vstar
 * @email vstar@gmail.com
 * @date 2018-11-21 19:05:33
 */
@Mapper
public interface DictionaryDao extends BaseDao<Query> {
	@Select("SELECT d_name AS `name`,d_key AS `key` FROM cm_dictionary WHERE type=#{value} ORDER BY order_by")
	List<Query> queryDictsByType(String type);
	@Select("SELECT type,d_name AS `name`,d_key AS `key` FROM cm_dictionary WHERE type in (${value}) ORDER BY type,order_by")
	List<Query> queryDictsInTypes(String types);
}
